git /*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 80018
 Source Host           : localhost:3306
 Source Schema         : dishdb

 Target Server Type    : MySQL
 Target Server Version : 80018
 File Encoding         : 65001

 Date: 13/01/2021 13:12:06
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for activity
-- ----------------------------
DROP TABLE IF EXISTS `activity`;
CREATE TABLE `activity` (
  `activityId` int(11) NOT NULL AUTO_INCREMENT,
  `full` double(255,0) DEFAULT NULL,
  `decrease` double(255,0) DEFAULT NULL,
  PRIMARY KEY (`activityId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of activity
-- ----------------------------
BEGIN;
INSERT INTO `activity` VALUES (22, 10, 5);
COMMIT;

-- ----------------------------
-- Table structure for address
-- ----------------------------
DROP TABLE IF EXISTS `address`;
CREATE TABLE `address` (
  `addressId` int(11) NOT NULL AUTO_INCREMENT,
  `addressName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  PRIMARY KEY (`addressId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of address
-- ----------------------------
BEGIN;
INSERT INTO `address` VALUES (14, '广东省深圳市软件园');
COMMIT;

-- ----------------------------
-- Table structure for dish
-- ----------------------------
DROP TABLE IF EXISTS `dish`;
CREATE TABLE `dish` (
  `dishId` int(11) NOT NULL AUTO_INCREMENT,
  `dishName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `price` double(255,2) NOT NULL,
  `dishType` enum('STAPLE','VEGETABLE','MEAT','DRINKS') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  PRIMARY KEY (`dishId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of dish
-- ----------------------------
BEGIN;
INSERT INTO `dish` VALUES (10, '米饭', 1.00, 'STAPLE', 'http://localhost:8080/dishPic/1606638620886mifan.png');
INSERT INTO `dish` VALUES (11, '鸡腿', 6.00, 'MEAT', 'http://localhost:8080/dishPic/1606638649672roujitui.png');
INSERT INTO `dish` VALUES (12, '白菜', 3.00, 'VEGETABLE', 'http://localhost:8080/dishPic/16066386688491606532740388vegetable1.png');
INSERT INTO `dish` VALUES (13, '可乐', 10.00, 'DRINKS', 'http://localhost:8080/dishPic/1606638699550yinliao_3.png');
INSERT INTO `dish` VALUES (14, '蛋糕', 35.00, 'STAPLE', 'http://localhost:8080/dishPic/160663896933518.jpg');
INSERT INTO `dish` VALUES (15, '面包', 13.00, 'STAPLE', 'http://localhost:8080/dishPic/160663904264022.jpg');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
